<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateVhuUsersTable extends Migration {

	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
		Schema::create('vhu_users', function(Blueprint $table)
		{
			$table->increments('idUser');
			$table->string('username');
			$table->string('password',66);
			$table->string('HoTen',150);
			$table->date('NgaySinh');
			$table->tinyInteger('GioiTinh');
			$table->string('Email');
			$table->string('SoDT',20);
			$table->string('urlHinh',150);
			$table->String('activation_code',100);
			$table->datetime('last_active');
			$table->timestamps();
			$table->string('remember_token',100);
			$table->tinyInteger('HienThi');
			$table->unique(array('username','Email'));
		});
	}

	/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down()
	{
		Schema::drop('vhu_users');
	}

}
